package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestConnection {
	private static Connection con = null;
	private static final String DRIVER = "com.mysql.jdbc.Driver" ;
	private static final String URL = "jdbc:mysql56://localhost:3306/test";
	private static final String USER = "root";
	private static final String PASS = "ab1234CD";
	public  TestConnection()throws Exception{
		Class.forName(DRIVER);
		System.out.println("Success loading Mysql Driver!");
		con = DriverManager.getConnection(URL,USER,PASS);
		System.out.println("Success connect Mysql Driver!");
	}
	public Connection getCon() throws Exception{
		return con;
	}
	public void close()throws Exception{
		if(con!=null){
			con.close();
		}
	}
/*  测试MySQL连接是否成功

	public static void main(String args[]) {
		 try {
		      Class.forName("com.mysql.jdbc.Driver");     //加载MYSQL JDBC驱动程序   
		      //Class.forName("org.gjt.mm.mysql.Driver");
		     System.out.println("Success loading Mysql Driver!");
		    }
		    catch (Exception e) {
		      System.out.print("Error loading Mysql Driver!");
		      e.printStackTrace();
		    }
		    try {
		      Connection connect = DriverManager.getConnection(
		          "jdbc:mysql://localhost:3306/test","root","ab1234CD");
		           //连接URL为   jdbc:mysql//服务器地址/数据库名  ，后面的2个参数分别是登陆用户名和密码
		 
		      System.out.println("Success connect Mysql server!");
		      Statement stmt = connect.createStatement();
		      ResultSet rs = stmt.executeQuery("select * from users");
		      System.out.println(rs);                                                     //user 为你表的名称
		      while (rs.next()) {
		    	System.out.print("卡号:"+rs.getString("Id")+"  ");
		        System.out.print("用户名:"+rs.getString("name")+"  ");
		        System.out.println("密码:"+rs.getString("password"));
		      }
		    }
		    catch (Exception e) {
		      System.out.print("get data error!");
		      e.printStackTrace();
		    }
		  }
	**/
}

